﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_RCBCJL')
            and   type = 'U')
   drop table GXBZ_EMR_RCBCJL
go

/*==============================================================*/
/* Table: GXBZ_EMR_RCBCJL                                       */
/*==============================================================*/
create table GXBZ_EMR_RCBCJL (
   JLLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   CJSJ                 datetime             null,
   WDCJZGH              varchar(64)          null,
   WDCJZXM              varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   QMRQSJ               datetime             null,
   YSGH                 varchar(64)          null,
   YSXM                 varchar(30)          null,
   ZYJSZWLBDM           varchar(30)          null,
   ZYJSZWLBMC           varchar(100)         null,
   JLRQSJ               datetime             null,
   BCH                  varchar(20)          null,
   BCHMC                varchar(100)         null,
   BFH                  varchar(20)          null,
   BFHMC                varchar(100)         null,
   KSBM                 varchar(20)          null,
   KSMC                 varchar(100)         null,
   BQBM                 varchar(20)          null,
   BQMC                 varchar(100)         null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   ZYBC                 varchar(4000)        null,
   ZYSZGCJG             varchar(1024)        null,
   YZNR                 varchar(1024)        null,
   BZLZ                 varchar(1024)        null,
   ZYJZFF               varchar(100)         null,
   ZYYYFF               varchar(100)         null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_RCBCJL primary key (JLLSH, XGBZ)
)
go
